﻿<?xml version="1.0" encoding="utf-8" ?>
<entities>
  <entity class="demo.Objects.Model.ScoreInfo" table="score" dal-class="demo.Objects.DAL.ScoreDAL" default-orderby-express="studentId">
    <key-property name="studentId" column="student_id" type="System.Int32" />
    <property name="courseId" column="course_id" type="System.String"/>
    <property name="score" column="score" type="System.Double"/>
    <ref-property name="student"
                  ref-entity="demo.Objects.Model.StudentInfo"
                  ref-property="studentId"
                  ref-display-property="studentName"
                  property="studentId"
                  ref-mode="leftjoin"/>
    <ref-property name="course"
                  ref-entity="demo.Objects.Model.CourseInfo"
                  ref-property="courseId"
                  ref-display-property="courseName"
                  property="courseId"
                  ref-mode="leftjoin"/>
  </entity>

  <entity class="demo.Objects.Model.StudentInfo" table="student" dal-class="demo.Objects.DAL.StudentDAL" default-orderby-express="studentId">
    <key-property name="studentId" column="student_id" type="System.Int32"/>
    <property name="studentName" column="student_name" type="System.String"/>
  </entity>

  <entity class="demo.Objects.Model.CourseInfo" table="course" dal-class="demo.Objects.DAL.CourseDAL" default-orderby-express="courseId">
    <key-property name="courseId" column="course_id" type="System.Int32"/>
    <property name="courseName" column="course_name" type="System.String"/>
  </entity>

</entities>
